package anbook.dao;

import java.util.List;

import anbook.dto.Member;

public interface IMemberDAO {
	boolean insertMember(Member member);
	void removeMember(String email);
	void updateMember(Member member);
	Member getMember(String email);
	List<String> findEmail(String nicname);
	String findPassword(String email, String nicname);
	
	public static final String SQL_DELETE_MEMBER = "delete from members where mb_email = ?";
	public static final String SQL_INSERT_MEMBER = "insert into members(mb_email,mb_password,mb_birth,mb_sex,mb_profile,mb_nicname,mb_local,mb_date) value(?,?,?,?,null,?,?,now())";
	public static final String SQL_UPDATE_MEMBER = "update members set mb_password = ?,mb_birth = ?,mb_sex = ?,mb_profile = ?,mb_nicname = ?,mb_local = ? where mb_email = ?";
	public static final String SQL_SELECT_MEMBER = "select * from members where mb_email = ?";
	public static final String SQL_FIND_ID = "select mb_email from members where mb_nicname=?";
	public static final String SQL_FIND_PASS = "select mb_password from members where mb_email=? and mb_nicname=?";
}
